2013-10-18 - 9591.100 - Rel Notes - Rewrite BI FI Reports to use New Query - Release 007 #BIReleases2013
Release Notes
9591.100 - Rewrite BI FI Reports to use New Query
Admin Info
Purpose
|
Need to Rewrite BI FI Reports to use New Query
|
Release No
|
007
|
Submitted
|
10/18/2013
|
Submitted by
|
Praveen Guntuka
|
Source/Destination Systems
|
IT > BMS > Production in Development Server to Reports > Financial Statements folder in Production Server
|
Release Sent To
|
Lori Miterko
|
Object(s) Created By
|
Praveen Guntuka
|
Object(s) Tested By
|
Joan Profetta
|
Report Name
FI120 - Income Statement in Company Currency
BEx Query
ZMP_GLPC_Q009
NEC Crystal Reports Standards Check
1. FI120 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. FI120 NEC CR checklist has been sent to NEC and also attached here for reference:
FI120 NEC CR Standard Check List.xlsx
Summary Level Check
Test Conducted
NEC Germany Corp. > Sales Net
SNo
|
Test Case
|
Value in DEV report
|
Value in Production Report
|
Pass/Fail
|
1
|
Actual
|
120,675
|
120,675
|
Pass
|
2
|
Budget
|
91,315
|
91,315
|
Pass
|
3
|
Variance
|
29,360
|
29,360
|
Pass
|
4
|
Var%
|
32
|
32
|
Pass
|
5
|
Actual
|
1,021,802
|
1,021,802
|
Pass
|
6
|
Budget
|
702,803
|
702,803
|
Pass
|
7
|
Variance
|
318,999
|
318,999
|
Pass
|
8
|
Var%
|
45
|
45
|
Pass
|
NEC Germany Corp. > Cost of goods sold
SNo
|
Test Case
|
Value in DEV report
|
Value in Production Report
|
Pass/Fail
|
1
|
Actual
|
11,961
|
11,961
|
Pass
|
2
|
Budget
|
28,020
|
28,020
|
Pass
|
3
|
Variance
|
-16,059
|
-16,059
|
Pass
|
4
|
Var%
|
-57
|
-57
|
Pass
|
5
|
Actual
|
314,965
|
314,965
|
Pass
|
6
|
Budget
|
215,656
|
215,656
|
Pass
|
7
|
Variance
|
99,309
|
99,309
|
Pass
|
8
|
Var%
|
46
|
46
|
Pass
|
NEC Germany Corp. > Selling and Distribution expenses
SNo
|
Test Case
|
Value in DEV report
|
Value in Production Report
|
Pass/Fail
|
1
|
Actual
|
131,800
|
131,800
|
Pass
|
2
|
Budget
|
113,601
|
113,601
|
Pass
|
3
|
Variance
|
18,199
|
18,199
|
Pass
|
4
|
Var%
|
16
|
16
|
Pass
|
5
|
Actual
|
1,466,079
|
1,466,079
|
Pass
|
6
|
Budget
|
1,290,592
|
1,290,592
|
Pass
|
7
|
Variance
|
175,487
|
175,487
|
Pass
|
8
|
Var%
|
14
|
14
|
Pass
|
NEC Germany Corp. > Other Income(expense)
SNo
|
Test Case
|
Value in DEV report
|
Value in Production Report
|
Pass/Fail
|
1
|
Actual
|
159,917
|
159,917
|
Pass
|
2
|
Budget
|
104,167
|
104,167
|
Pass
|
3
|
Variance
|
55,750
|
55,750
|
Pass
|
4
|
Var%
|
54
|
54
|
Pass
|
5
|
Actual
|
1,007,238
|
1,007,238
|
Pass
|
6
|
Budget
|
937,503
|
937,503
|
Pass
|
7
|
Variance
|
69,735
|
69,735
|
Pass
|
8
|
Var%
|
7
|
7
|
Pass
|
NEC Germany Corp. > Tax Provision
SNo
|
Test Case
|
Value in DEV report
|
Value in Production Report
|
Pass/Fail
|
1
|
Actual
|
35,858
|
35,858
|
Pass
|
2
|
Budget
|
0
|
0
|
Pass
|
3
|
Variance
|
35,858
|
35,858
|
Pass
|
4
|
Var%
|
0
|
0
|
Pass
|
5
|
Actual
|
117,417
|
117,417
|
Pass
|
6
|
Budget
|
0
|
0
|
Pass
|
7
|
Variance
|
117,417
|
117,417
|
Pass
|
8
|
Var%
|
0
|
0
|
Pass
|
Detail Level Check
Test Conducted
NEC Era Australia Pty Lim > Cost of goods sold > Supplies
SNo
|
Test Case
|
Value in DEV report
|
Value in Production Report
|
Pass/Fail
|
1
|
Actual
|
0
|
0
|
Pass
|
2
|
Budget
|
200
|
200
|
Pass
|
3
|
Variance
|
-200
|
-200
|
Pass
|
4
|
Var%
|
-100
|
-100
|
Pass
|
5
|
Actual
|
2,759
|
2,759
|
Pass
|
6
|
Budget
|
1,000
|
1,000
|
Pass
|
7
|
Variance
|
1,759
|
1,759
|
Pass
|
8
|
Var%
|
176
|
176
|
Pass
|
NEC Era Australia Pty Lim > Tax Provision > Australia Income Tax
SNo
|
Test Case
|
Value in DEV report
|
Value in Production Report
|
Pass/Fail
|
1
|
Actual
|
0
|
0
|
Pass
|
2
|
Budget
|
0
|
0
|
Pass
|
3
|
Variance
|
0
|
0
|
Pass
|
4
|
Var%
|
0
|
0
|
Pass
|
5
|
Actual
|
504,789
|
504,789
|
Pass
|
6
|
Budget
|
300,000
|
300,000
|
Pass
|
7
|
Variance
|
204,789
|
204,789
|
Pass
|
8
|
Var%
|
68
|
68
|
Pass
|
Reference Document(Specification)
2013-10-18 - 9591.100 - Spec - Rewrite BI FI Reports to use New Query
2013-10-18 - 9591.100 - Rel Notes - Rewrite BI FI Reports to use New Query - Release 001
2013-10-18 - 9591.100 - Rel Notes - Rewrite BI FI Reports to use New Query - Release 002
2013-10-18 - 9591.100 - Rel Notes - Rewrite BI FI Reports to use New Query - Release 003
2013-10-18 - 9591.100 - Rel Notes - Rewrite BI FI Reports to use New Query - Release 004
2013-10-18 - 9591.100 - Rel Notes - Rewrite BI FI Reports to use New Query - Release 005
2013-10-18 - 9591.100 - Rel Notes - Rewrite BI FI Reports to use New Query - Release 006